Interview Room | Filtered

Go to Tips Page

Tech Support

Prepare for InterviewPrepare for Interview
AcknowledgementsAcknowledgements
Test hardwareTest hardware
What to ExpectWhat to Expect
Start InterviewStart Interview
Video QuestionVideo Question
Video QuestionVideo Question
Video QuestionVideo Question
Algorithm QuestionAlgorithm Question
SQL QuestionSQL Question
Data Science QuestionData Science Question
AvailabilityAvailability
Preview & SubmitPreview & Submit
Finish InterviewFinish Interview

Test Hardware

All checks passed

Please click 'CONTINUE' button at the bottom to move on.

Network latency:

Passed

Consider disabling Adblock or similar browser plugin and then reload the page.
Consider connecting to a VPN service.
Consider connecting to the internet from a different location.
Consider closing all other programs that need access to the internet.

Sound Input:

Passed

Sound Output:

Passed

Please click the icon next to the address bar in your browser to verify or modify the audio permissions. (Reload the page to apply changes.)
Try choosing different sound output sources from the dropdown.
Try changing your operating system settings to enable an output device.
Please troubleshoot WebRTC on this site (opens in a new tab).

Camera:

Passed

Please click the icon next to the address bar in your browser to verify or modify the camera permissions. (Reload the page to apply changes.)
Check your browser settings to verify that hardware access can be given to Filtered.
Try choosing different camera input sources from the dropdown.
Try fully closing and restarting your browser or computer.
Try changing your operating system settings to enable a camera.
Please troubleshoot WebRTC on this site (opens in a new tab).

File Upload:

Passed

If you're using the internet at the office or on a company computer, a firewall or proxy may be blocking your ability to upload. Please connect to a different internet network or consider using a personal computer.

Back Continue

Type	Notes	Time Limit	Sample Playground
Video	You can re-record this video	3 min	Try a sample
Video	You can re-record this video	3 min	Try a sample
Video	You can re-record this video	3 min	Try a sample
Coding (Algorithm)	Languages Allowed: Java, Javascript, Python-3, PHP-7, Ruby, C, C++, Go, Scala, Objective-C, Swift-5	No	Try a sample
Coding (SQL)	Languages Allowed: SQL	No	Try a sample
Coding (Data Science)	Languages Allowed: Python-3, R	No	Try a sample

Question 5/6

"Investor Performance"

Your solution will be scored against expected output.

The table, INVESTOR_TABLE_2019, contains performance data for the investors working at an investment company in 2019.

Write a query which will return the INVESTOR_IDs of the investors whose investment accounts experienced a greater than average percentage return in 2019 amongst all investors. Order your results by INVESTOR_ID in ascending order.

In the returned query be sure to use the column names used in the sample output given below.

Data:

Table Name : INVESTOR_TABLE_2019

Sample Input:

Sample Output:

Explanation:

The percentage returns for investors 196208, 196202, 196212, and 196298 are 0.10, -0.70, 1.00, and 0.20 respectively, which means the average percent return amongst these investors is 0.15.

Therefore, the sample output consists of two rows containing the investor ids of the two investors who attained higher than average percentage returns.

Time 0:03 Run Submit

Enter to Rename, Shift+Enter to Preview

Query Results

Run a query to see results

Database Schema

**INVESTOR_TABLE_2019***50 rows*
INVESTOR_ID	INT
OFFICE_ID	INT
INITIAL_ACCOUNT_VALUE	DOUBLE
FINAL_ACCOUNT_VALUE	DOUBLE

Acknowledgements

Test Hardware

All checks passed

What to expect

Data:

Sample Input:

Sample Output:

Explanation:

Submit this question?

Try Sample Playground

You are about to be directed to a sample VIDEO playground, it is optional and NOT part of the interview. You can choose to skip the playground and click continue to start the interview or go to the playground.

Try Sample Playground

You are about to be directed to a sample CODING playground, it is optional and NOT part of the interview. You can choose to skip the playground and click continue to start the interview or go to the playground.

Try Sample Playground

You are about to be directed to a sample SQL playground, it is optional and NOT part of the interview. You can choose to skip the playground and click continue to start the interview or go to the playground.

Try Sample Playground

You are about to be directed to a sample DATA playground, it is optional and NOT part of the interview. You can choose to skip the playground and click continue to start the interview or go to the playground.

Before you continue...

Submit this video explanation?

Success!